<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<%@include file = "lianjie.jsp" %>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<form name = "fm">
		<table width = "70%" border = "1" cellpadding="3" cellspacing="0">
			<tr>
				<th width = "15%">ID</th>
				<th width = "15%">username</th>
				<th width = "15%">password</th>
				<th width = "15%">sex</th>
				<th width = "15%">tel</th>
			</tr>
			<%
			
				String ID = "";
				String all_username = "";
				String password = "";
				String sex = "";
				String tel = "";				
				String select_sql = "select * from usermassage where kind = '0'";
				ResultSet rs1 = stmt.executeQuery(select_sql);
				while(rs1.next()){
					ID = rs1.getString("ID");
					all_username = rs1.getString("username");
					password = rs1.getString("password");
					sex = rs1.getString("sex");
					tel = rs1.getString("tel");
			%>
			<tr align = "center">
				<td><%=ID %></td>
				<td><%=all_username %></td>
				<td><%=password %></td>
				<td><%=sex %></td>
				<td><%=tel %></td>
			</tr>
			<%
				}
			%>
		</table>
		<br><br><br>
		<div align = "center">
	
			<input type = "submit" name = "button" value = "返回" onClick = "back_back()" style = "font-size:20px;font-family:'微软雅黑'">
		</div>
	</form>
</body>
<script>
	function back_back(){
		document.fm.action = "teacher.jsp";
	}
</script>
</html>